Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2972
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	302.0 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Alerts

`gross_revenue` is highly correlated with `qnt_invoices` and 4 other fields	High correlation
`recency_days` is highly correlated with `qnt_invoices`	High correlation
`qnt_invoices` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qnt_items` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`qnt_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `qnt_returns` and 1 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `avg_basket_size`	High correlation
`qnt_returns` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 25.17370854)	Skewed
`frequency` is highly skewed (γ1 = 22.48955714)	Skewed
`qnt_returns` is highly skewed (γ1 = 21.9900238)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 89 (3.0%) zeros	Zeros
`qnt_returns` has 1484 (49.9%) zeros	Zeros

Reproduction

Analysis started	2022-11-08 12:34:17.395328
Analysis finished	2022-11-08 12:34:48.730274
Duration	31.33 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2972
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2319.925976

Minimum	0
Maximum	5724
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	185.55
Q1	929.75
median	2121.5
Q3	3540.25
95-th percentile	5041.9
Maximum	5724
Range	5724
Interquartile range (IQR)	2610.5

Descriptive statistics

Standard deviation	1556.821729
Coefficient of variation (CV)	0.6710652602
Kurtosis	-1.00981964
Mean	2319.925976
Median Absolute Deviation (MAD)	1272
Skewness	0.3427524776
Sum	6894820
Variance	2423693.895
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3013	1	< 0.1%
3000	1	< 0.1%
3001	1	< 0.1%
3002	1	< 0.1%
3003	1	< 0.1%
3006	1	< 0.1%
3008	1	< 0.1%
3009	1	< 0.1%
3011	1	< 0.1%
Other values (2962)	2962	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5724	1	< 0.1%
5705	1	< 0.1%
5695	1	< 0.1%
5689	1	< 0.1%
5668	1	< 0.1%
5664	1	< 0.1%
5658	1	< 0.1%
5647	1	< 0.1%
5646	1	< 0.1%
5636	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2972
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15269.35902

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12617.65
Q1	13798.75
median	15219
Q3	16767.25
95-th percentile	17964.45
Maximum	18287
Range	5940
Interquartile range (IQR)	2968.5

Descriptive statistics

Standard deviation	1719.023795
Coefficient of variation (CV)	0.1125799579
Kurtosis	-1.205173491
Mean	15269.35902
Median Absolute Deviation (MAD)	1487.5
Skewness	0.03231443878
Sum	45380535
Variance	2955042.808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
14759	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
15912	1	< 0.1%
12670	1	< 0.1%
Other values (2962)	2962	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12363	1	< 0.1%
12364	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2957
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2690.963509

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.8825
Q1	570.49
median	1083.905
Q3	2303.175
95-th percentile	7155.426
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1732.685

Descriptive statistics

Standard deviation	10128.87831
Coefficient of variation (CV)	3.764034064
Kurtosis	397.8197927
Mean	2690.963509
Median Absolute Deviation (MAD)	668.435
Skewness	17.64673284
Sum	7997543.55
Variance	102594175.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1078.96	2	0.1%
331	2	0.1%
1025.44	2	0.1%
598.2	2	0.1%
731.9	2	0.1%
533.33	2	0.1%
379.65	2	0.1%
2092.32	2	0.1%
745.06	2	0.1%
889.93	2	0.1%
Other values (2947)	2952	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	305
Distinct (%)	10.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.88829071

Minimum	0
Maximum	372
Zeros	89
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	372
Range	372
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.75289227
Coefficient of variation (CV)	1.217013187
Kurtosis	2.761781321
Mean	63.88829071
Median Absolute Deviation (MAD)	26
Skewness	1.793794175
Sum	189876
Variance	6045.512256
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	99	3.3%
0	89	3.0%
1	82	2.8%
2	82	2.8%
7	72	2.4%
9	66	2.2%
8	64	2.2%
4	60	2.0%
10	59	2.0%
15	58	2.0%
Other values (295)	2241	75.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	89	3.0%
1	82	2.8%
2	82	2.8%
3	99	3.3%
4	60	2.0%
5	20	0.7%
6	38	1.3%
7	72	2.4%
8	64	2.2%
9	66	2.2%

Value	Count	Frequency (%)
372	3	0.1%
371	4	0.1%
368	1	< 0.1%
366	1	< 0.1%
365	5	0.2%
363	1	< 0.1%
359	2	0.1%
357	4	0.1%
354	1	< 0.1%
353	1	< 0.1%

qnt_invoices
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.719717362

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.852726069
Coefficient of variation (CV)	1.547755861
Kurtosis	190.9881794
Mean	5.719717362
Median Absolute Deviation (MAD)	2
Skewness	10.77090171
Sum	16999
Variance	78.37075886
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	787	26.5%
3	500	16.8%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	190	6.4%
2	787	26.5%
3	500	16.8%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qnt_items
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1670
Distinct (%)	56.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1580.63459

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	102.55
Q1	296.75
median	638
Q3	1399
95-th percentile	4402.25
Maximum	196844
Range	196843
Interquartile range (IQR)	1102.25

Descriptive statistics

Standard deviation	5701.592811
Coefficient of variation (CV)	3.607154271
Kurtosis	517.4081275
Mean	1580.63459
Median Absolute Deviation (MAD)	419
Skewness	18.74961311
Sum	4697646
Variance	32508160.58
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	9	0.3%
88	9	0.3%
288	8	0.3%
260	8	0.3%
246	8	0.3%
84	8	0.3%
272	8	0.3%
1200	7	0.2%
330	7	0.2%
Other values (1660)	2889	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%
50255	1	< 0.1%

qnt_products
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	468
Distinct (%)	15.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.6554509

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.7680824
Coefficient of variation (CV)	2.199397422
Kurtosis	355.1958
Mean	122.6554509
Median Absolute Deviation (MAD)	44
Skewness	15.71492065
Sum	364532
Variance	72774.8183
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	43	1.4%
20	37	1.2%
35	35	1.2%
29	35	1.2%
19	34	1.1%
15	33	1.1%
11	32	1.1%
26	31	1.0%
27	30	1.0%
25	30	1.0%
Other values (458)	2632	88.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	15	0.5%
4	17	0.6%
5	26	0.9%
6	29	1.0%
7	18	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	2969
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.9767625

Minimum	2.150588235
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.91898044
Q1	13.12080108
median	17.96548505
Q3	24.88290741
95-th percentile	89.807625
Maximum	4453.43
Range	4451.279412
Interquartile range (IQR)	11.76210633

Descriptive statistics

Standard deviation	119.452561
Coefficient of variation (CV)	3.622325297
Kurtosis	814.050302
Mean	32.9767625
Median Absolute Deviation (MAD)	5.974456424
Skewness	25.17370854
Sum	98006.93816
Variance	14268.91433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
15	2	0.1%
4.162	2	0.1%
18.15222222	1	< 0.1%
29.78416667	1	< 0.1%
22.8792623	1	< 0.1%
20.51104167	1	< 0.1%
149.025	1	< 0.1%
21.47435897	1	< 0.1%
12.949	1	< 0.1%
Other values (2959)	2959	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1258
Distinct (%)	42.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.29286573

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.9271978
median	48.225
Q3	85.33333333
95-th percentile	200.45
Maximum	366
Range	365
Interquartile range (IQR)	59.40613553

Descriptive statistics

Standard deviation	63.48195335
Coefficient of variation (CV)	0.9433682554
Kurtosis	4.910702354
Mean	67.29286573
Median Absolute Deviation (MAD)	26.225
Skewness	2.066265291
Sum	199994.397
Variance	4029.958401
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
46	17	0.6%
11	17	0.6%
21	17	0.6%
6	16	0.5%
Other values (1248)	2780	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	1233
Distinct (%)	41.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1178686684

Minimum	0.005464480874
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.005464480874
5-th percentile	0.008928571429
Q1	0.01639344262
median	0.02601156069
Q3	0.0498097723
95-th percentile	1
Maximum	17
Range	16.99453552
Interquartile range (IQR)	0.03341632968

Descriptive statistics

Standard deviation	0.4289909165
Coefficient of variation (CV)	3.639567007
Kurtosis	822.4442034
Mean	0.1178686684
Median Absolute Deviation (MAD)	0.0122500928
Skewness	22.48955714
Sum	350.3056823
Variance	0.1840332065
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	196	6.6%
0.02380952381	17	0.6%
0.0625	16	0.5%
0.01587301587	15	0.5%
0.04545454545	14	0.5%
0.01923076923	14	0.5%
0.02941176471	14	0.5%
0.07692307692	13	0.4%
0.07142857143	13	0.4%
0.0303030303	13	0.4%
Other values (1223)	2647	89.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005464480874	1	< 0.1%
0.005479452055	2	0.1%
0.005494505495	1	< 0.1%
0.005602240896	3	0.1%
0.005633802817	2	0.1%
0.005681818182	1	< 0.1%
0.005698005698	3	0.1%
0.005714285714	4	0.1%
0.005730659026	1	< 0.1%
0.005747126437	1	< 0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
6	1	< 0.1%
4	1	< 0.1%
2	9	0.3%
1.5	1	< 0.1%
1.333333333	1	< 0.1%
1	196	6.6%
0.6666666667	3	0.1%
0.5549597855	1	< 0.1%
0.5361930295	1	< 0.1%

qnt_returns
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	213
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.84219381

Minimum	0
Maximum	9014
Zeros	1484
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	100
Maximum	9014
Range	9014
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	282.6771169
Coefficient of variation (CV)	8.113068839
Kurtosis	596.9987163
Mean	34.84219381
Median Absolute Deviation (MAD)	1
Skewness	21.9900238
Sum	103551
Variance	79906.3524
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1484	49.9%
1	164	5.5%
2	149	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	51	1.7%
7	43	1.4%
8	43	1.4%
Other values (203)	705	23.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1484	49.9%
1	164	5.5%
2	149	5.0%
3	105	3.5%
4	89	3.0%
5	61	2.1%
6	78	2.6%
7	43	1.4%
8	43	1.4%
9	41	1.4%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1979
Distinct (%)	66.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	236.23718

Minimum	1
Maximum	6009.333333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.2875
median	172.2916667
Q3	281.5480769
95-th percentile	599.34
Maximum	6009.333333
Range	6008.333333
Interquartile range (IQR)	178.2605769

Descriptive statistics

Standard deviation	283.7187909
Coefficient of variation (CV)	1.20099127
Kurtosis	102.9007053
Mean	236.23718
Median Absolute Deviation (MAD)	82.91666667
Skewness	7.705881095
Sum	702096.899
Variance	80496.35234
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
82	9	0.3%
86	9	0.3%
73	9	0.3%
75	8	0.3%
136	8	0.3%
60	8	0.3%
88	8	0.3%
163	7	0.2%
Other values (1969)	2885	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	906
Distinct (%)	30.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.49043914

Minimum	0.2
Maximum	259
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.698924731
median	13.6125
Q3	22.14464286
95-th percentile	46
Maximum	259
Range	258.8
Interquartile range (IQR)	14.44571813

Descriptive statistics

Standard deviation	15.45136768
Coefficient of variation (CV)	0.883417938
Kurtosis	29.35401251
Mean	17.49043914
Median Absolute Deviation (MAD)	6.6125
Skewness	3.437673424
Sum	51981.58512
Variance	238.7447631
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	42	1.4%
9	41	1.4%
16	39	1.3%
8	39	1.3%
14	38	1.3%
17	38	1.3%
5	36	1.2%
7	36	1.2%
11	36	1.2%
15	35	1.2%
Other values (896)	2592	87.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
177	1	< 0.1%
148	1	< 0.1%
127	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
101	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qnt_invoices	qnt_items	qnt_products	avg_ticket	avg_recency_days	frequency	qnt_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.21	371.0	34.0	1733.0	297.0	18.152222	35.500000	17.000000	40.0	50.970588	0.617647
1	1	13047	3232.59	56.0	9.0	1390.0	171.0	18.904035	27.250000	0.028302	35.0	154.444444	11.666667
2	2	12583	6705.38	2.0	15.0	5028.0	232.0	28.902500	23.187500	0.040431	50.0	335.200000	7.600000
3	3	13748	948.25	95.0	5.0	439.0	28.0	33.866071	92.666667	0.017921	0.0	87.800000	4.800000
4	4	15100	876.00	333.0	3.0	80.0	3.0	292.000000	8.600000	0.073171	22.0	26.666667	0.333333
5	5	15291	4623.30	25.0	14.0	2102.0	102.0	45.326471	23.200000	0.040115	29.0	150.142857	4.357143
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	17.219786	18.300000	0.057221	399.0	172.428571	7.047619
7	7	17809	5411.91	15.0	12.0	2057.0	61.0	88.719836	35.700000	0.033520	41.0	171.416667	3.833333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.543464	4.144444	0.243316	474.0	419.714286	6.230769
9	9	16098	2005.63	87.0	7.0	613.0	67.0	29.934776	47.666667	0.027875	0.0	87.571429	4.857143

Last rows

	df_index	customer_id	gross_revenue	recency_days	qnt_invoices	qnt_items	qnt_products	avg_ticket	avg_recency_days	frequency	qnt_returns	avg_basket_size	avg_unique_basket_size
2962	5636	17727	1060.25	14.0	1.0	645.0	66.0	16.064394	6.0	1.000000	6.0	645.000000	66.000000
2963	5646	17232	421.52	2.0	2.0	203.0	36.0	11.708889	12.0	0.166667	0.0	101.500000	15.000000
2964	5647	17468	137.00	9.0	2.0	116.0	5.0	27.400000	4.0	0.400000	0.0	58.000000	2.500000
2965	5658	13596	697.04	5.0	2.0	406.0	166.0	4.199036	7.0	0.250000	0.0	203.000000	66.500000
2966	5664	14893	1237.85	9.0	2.0	799.0	73.0	16.956849	2.0	0.666667	0.0	399.500000	36.000000
2967	5668	12479	473.20	10.0	1.0	382.0	30.0	15.773333	4.0	1.000000	34.0	382.000000	30.000000
2968	5689	14126	706.13	7.0	3.0	508.0	15.0	47.075333	3.0	1.000000	50.0	169.333333	4.666667
2969	5695	13521	1092.39	0.0	3.0	733.0	435.0	2.511241	4.5	0.333333	0.0	244.333333	104.000000
2970	5705	15060	301.84	7.0	4.0	262.0	120.0	2.515333	1.0	4.000000	0.0	65.500000	20.000000
2971	5724	12558	269.96	7.0	1.0	196.0	11.0	24.541818	6.0	1.000000	196.0	196.000000	11.000000

Overview

Variables

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows